package com.koron.css2.newProjectCenter.mapper;


import com.koron.css2.newProjectCenter.bean.PjPubUpDealings;
import com.koron.css2.newProjectCenter.bean.query.PjPubUpDealingsQuery;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author: 苏小龙
 * @CreateTime: 2024-12-03
 * @Description: 往来单位
 * @Version: 1.0
 */
public interface PjPubUpDealingsMapper {
    List<PjPubUpDealings> getList(PjPubUpDealingsQuery pjPubUpDealingsQuery);
    int deleteById(String id);

    void insert(PjPubUpDealings pjPubUpDealings);
    void update(PjPubUpDealings pjPubUpDealings);

    @Select("select count(*) from pub_up_material where is_deleted = false and (manufacturer = #{id} or supplier = #{id})")
    int hasDataById(String id);
}
